package com.spark.laboratory.mapper;

import com.spark.laboratory.pojo.Users;
import com.spark.laboratory.pojo.UsersExample;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface UsersMapper {
    long countByExample(UsersExample example);

    int deleteByExample(UsersExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(Users record);

    int insertSelective(Users record);

    List<Users> selectByExample(UsersExample example);

    Users selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") Users record, @Param("example") UsersExample example);

    int updateByExample(@Param("record") Users record, @Param("example") UsersExample example);

    int updateByPrimaryKeySelective(Users record);

    int updateByPrimaryKey(Users record);

    Users selectUsers_1(String userSchool, String userStudentNumber, String userName);

    Users selectUsers_2(String userSchool, String userName);

    Integer selectUserScoreGreaterThan(Integer passScore);

    Users selectByUserName(String userName);
}